using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Runtime.Serialization;

namespace KPIS.GERP.Models.BGM
{
	[Table("bgm_project_expense_plan"), DataContract]
    public class ProjectExpensePlan
    {
		[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
		[DataMember, Display(Name = "BgmProjExpPlanId", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
        [Column("bgm_proj_exp_plan_seq", TypeName="int")]
        public int ProjExpPlanId { get; set; }

        [ForeignKey("ProjectExpense")]
		[DataMember, Display(Name = "BgmProjExpId", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
        [Column("bgm_proj_exp_seq", TypeName="int")]
        public Nullable<int> ProjExpId { get; set; }

		[DataMember, Display(Name = "AmountMonth1", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month1", TypeName="decimal")]
        public Nullable<decimal> AmountMonth1 { get; set; }

		[DataMember, Display(Name = "AmountMonth2", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month2", TypeName="decimal")]
        public Nullable<decimal> AmountMonth2 { get; set; }

		[DataMember, Display(Name = "AmountMonth3", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month3", TypeName="decimal")]
        public Nullable<decimal> AmountMonth3 { get; set; }

		[DataMember, Display(Name = "AmountMonth4", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month4", TypeName="decimal")]
        public Nullable<decimal> AmountMonth4 { get; set; }

		[DataMember, Display(Name = "AmountMonth5", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month5", TypeName="decimal")]
        public Nullable<decimal> AmountMonth5 { get; set; }

		[DataMember, Display(Name = "AmountMonth6", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month6", TypeName="decimal")]
        public Nullable<decimal> AmountMonth6 { get; set; }

		[DataMember, Display(Name = "AmountMonth7", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month7", TypeName="decimal")]
        public Nullable<decimal> AmountMonth7 { get; set; }

		[DataMember, Display(Name = "AmountMonth8", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month8", TypeName="decimal")]
        public Nullable<decimal> AmountMonth8 { get; set; }

		[DataMember, Display(Name = "AmountMonth9", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month9", TypeName="decimal")]
        public Nullable<decimal> AmountMonth9 { get; set; }

		[DataMember, Display(Name = "AmountMonth10", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month10", TypeName="decimal")]
        public Nullable<decimal> AmountMonth10 { get; set; }

		[DataMember, Display(Name = "AmountMonth11", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month11", TypeName="decimal")]
        public Nullable<decimal> AmountMonth11 { get; set; }

		[DataMember, Display(Name = "AmountMonth12", ResourceType = typeof(Resources.ProjectExpensePlanResource))]
		[Column("amount_month12", TypeName="decimal")]
        public Nullable<decimal> AmountMonth12 { get; set; }

        [DataMember]
        public virtual ProjectExpense ProjectExpense { get; set; }



        #region RecordStatus

        [DataMember, Display(Name = "RecordStatus", ResourceType = typeof(SYS.Resources.RecordStatusResource))]
		[Column("record_status", TypeName="ntext")]
        public string RecordStatus { get; set; }

        [DataMember, Display(Name = "CreatedBy", ResourceType = typeof(SYS.Resources.RecordStatusResource))]
		[Column("created_by", TypeName="int")]
        public Nullable<int> CreatedBy { get; set; }

        [DataMember, Display(Name = "CreatedWhen", ResourceType = typeof(SYS.Resources.RecordStatusResource))]
		[Column("created_when", TypeName="datetime2")]
        public Nullable<System.DateTime> CreatedWhen { get; set; }

        [DataMember, Display(Name = "UpdatedBy", ResourceType = typeof(SYS.Resources.RecordStatusResource))]
		[Column("updated_by", TypeName="int")]
        public Nullable<int> UpdatedBy { get; set; }

        [DataMember, Display(Name = "UpdatedWhen", ResourceType = typeof(SYS.Resources.RecordStatusResource))]
		[Column("updated_when", TypeName="datetime2")]
        public Nullable<System.DateTime> UpdatedWhen { get; set; }

        #endregion

    }
}